package net.ywd.xp1024search.mapper;

import net.ywd.xp1024search.entity.UsdtCny;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

public interface UsdtCnyRepository extends JpaRepository<UsdtCny, Long> {

    @Query("select u from UsdtCny u where buy_rate <> 0 and sell_rate <> 0")
    List<UsdtCny> findWithout0();
}
